package com.ruoyi.cangku.mapper;

import com.ruoyi.cangku.domain.Shangpinguanli;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * sahngpinMapper接口
 *
 * @author ruoyi
 * @date 2023-11-07
 */
@Mapper
public interface ShangpinguanliMapper {
    /**
     * 查询sahngpin
     *
     * @param id sahngpin主键
     * @return sahngpin
     */
    Shangpinguanli selectShangpinguanliById(Integer id);

    /**
     * 查询sahngpin列表
     *
     * @param shangpinguanli sahngpin
     * @return sahngpin集合
     */
    List<Shangpinguanli> selectShangpinguanliList(Shangpinguanli shangpinguanli);

    /**
     * 新增sahngpin
     *
     * @param shangpinguanli sahngpin
     * @return 结果
     */
    int insertShangpinguanli(Shangpinguanli shangpinguanli);

    /**
     * 修改sahngpin
     *
     * @param shangpinguanli sahngpin
     * @return 结果
     */
    int updateShangpinguanli(Shangpinguanli shangpinguanli);

    /**
     * 删除sahngpin
     *
     * @param id sahngpin主键
     * @return 结果
     */
    int deleteShangpinguanliById(Integer id);

    /**
     * 批量删除sahngpin
     *
     * @param ids 需要删除的数据主键集合
     * @return 结果
     */
    int deleteShangpinguanliByIds(String[] ids);

    Shangpinguanli selectShangpinguanliByBianHao (String key);

    List<Shangpinguanli> selectShangpingList ();

    List<Shangpinguanli> selectShangpingMenList ();
}
